/*
 * util_sqlite.h
 *
 *  Created on: May 4, 2016
 *      Author: root
 */

#ifndef LIB_UTIL_UTIL_SQLITE_H_
#define LIB_UTIL_UTIL_SQLITE_H_
typedef struct {
    int wifi_id;
    int wifi_matser_id;
    char wifi_ssid[128];
    char wifi_password[128];
    char wifi_mac[128];
    double wifi_longitude;
    double wifi_latitude;
    int wifi_area_id;
} Wifilist;
typedef struct {
	int id;
    int wifi_id;
    int wifi_matser_id;
    char wifi_ssid[128];
    char wifi_password[128];
    char wifi_mac[128];
    double wifi_longitude;
    double wifi_latitude;
    int wifi_area_id;
} Wifilist_local;
int SQ_DBCreate(char *pucDBName, char *tableName );
int SQ_DBInsert(char *pucDBName, char *tableName ,Wifilist *wifilist,int num);
int SQ_DBSelect(char *pucDBName, char *tableName ,char *key,char *value,Wifilist_local *wifilist_local);
#endif /* LIB_UTIL_UTIL_SQLITE_H_ */
